Spread for ASP.NET 12 Product Documentation
SetConditionalFormatting(CellRange[],Boolean,IConditionalFormattingRule[]) Method


FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > SheetView Class > SetConditionalFormatting Method : SetConditionalFormatting(CellRange[],Boolean,IConditionalFormattingRule[]) Method
The cell ranges
Rule(s) can be merged into an existing conditional format if they affect the same cell range(s).
The specified rules to apply for a specified range of cells
Sets conditional formatting for specified ranges of cells on the sheet based on specified rules.
Syntax
'Declaration
 
Public Overloads Sub SetConditionalFormatting( _
   ByVal cellRanges() As CellRange, _
   ByVal combinable As Boolean, _
   ByVal ParamArray rules() As IConditionalFormattingRule _
) 
'Usage
 
Dim instance As SheetView
Dim cellRanges() As CellRange
Dim combinable As Boolean
Dim rules() As IConditionalFormattingRule
 
instance.SetConditionalFormatting(cellRanges, combinable, rules)
public void SetConditionalFormatting( 
   CellRange[] cellRanges,
   bool combinable,
   params IConditionalFormattingRule[] rules
)

Parameters

cellRanges
The cell ranges
combinable
Rule(s) can be merged into an existing conditional format if they affect the same cell range(s).
rules
The specified rules to apply for a specified range of cells
See Also

Reference

SheetView Class
SheetView Members
Overload List